<template>
	<vxe-grid ref="xGrid" v-bind="gridOptions" v-on="gridEvent"></vxe-grid>
</template>

<script lang="ts" setup name="Edit">
import { VXETable, VxeGridProps } from 'vxe-table';
import XEUtils from 'xe-utils';

interface RowVO {
	[key: string]: any;
}

const serveApiUrl = 'https://api.vxetable.cn/demo';

const xGrid = ref();

const gridOptions = reactive<VxeGridProps<RowVO>>({
	border: true,
	showHeaderOverflow: true,
	showOverflow: true,
	keepSource: true,
	id: 'full_edit_1',
	height: 600,
	rowConfig: {
		keyField: 'id',
		isHover: true,
	},
	columnConfig: {
		resizable: true,
	},
	customConfig: {
		storage: true,
		checkMethod({ column }) {
			if (['nickname', 'role'].includes(column.field)) {
				return false;
			}
			return true;
		},
	},
	printConfig: {
		columns: [
			{ field: 'name' },
			{ field: 'email' },
			{ field: 'nickname' },
			{ field: 'age' },
			{ field: 'amount' },
		],
	},
	sortConfig: {
		trigger: 'cell',
		remote: true,
	},
	filterConfig: {
		remote: true,
	},
	pagerConfig: {
		pageSize: 10,
		pageSizes: [5, 10, 15, 20, 50, 100, 200, 500, 1000],
	},
	formConfig: {
		titleWidth: 100,
		titleAlign: 'right',
		items: [
			{
				field: 'name',
				title: 'app.body.label.name',
				span: 8,
				titlePrefix: {
					message: 'app.body.valid.rName',
					icon: 'vxe-icon-question-circle-fill',
				},
				itemRender: { name: '$input', props: { placeholder: '请输入名称' } },
			},
			{
				field: 'email',
				title: '邮件',
				span: 8,
				titlePrefix: {
					useHTML: true,
					message:
						'点击链接：<a class="link" href="https://vxetable.cn" target="_blank">vxe-table官网</a>',
					icon: 'vxe-icon-question-circle-fill',
				},
				itemRender: { name: '$input', props: { placeholder: '请输入邮件' } },
			},
			{
				field: 'nickname',
				title: '昵称',
				span: 8,
				itemRender: { name: '$input', props: { placeholder: '请输入昵称' } },
			},
			{
				field: 'role',
				title: '角色',
				span: 8,
				folding: true,
				itemRender: { name: '$input', props: { placeholder: '请输入角色' } },
			},
			{
				field: 'sex',
				title: '性别',
				span: 8,
				folding: true,
				titleSuffix: {
					message: '注意，必填信息！',
					icon: 'vxe-icon-question-circle-fill',
				},
				itemRender: { name: '$select', options: [] },
			},
			{
				field: 'age',
				title: '年龄',
				span: 8,
				folding: true,
				itemRender: {
					name: '$input',
					props: {
						type: 'number',
						min: 1,
						max: 120,
						placeholder: '请输入年龄',
					},
				},
			},
			{
				span: 24,
				align: 'center',
				collapseNode: true,
				itemRender: {
					name: '$buttons',
					children: [
						{
							props: {
								type: 'submit',
								content: 'app.body.label.search',
								status: 'primary',
							},
						},
						{ props: { type: 'reset', content: 'app.body.label.reset' } },
					],
				},
			},
		],
	},
	toolbarConfig: {
		buttons: [
			{ code: 'insert_actived', name: '新增' },
			{ code: 'delete', name: '直接删除' },
			{ code: 'mark_cancel', name: '删除/取消' },
			{ code: 'save', name: 'app.body.button.save', status: 'success' },
		],
		refresh: true, // 显示刷新按钮
		import: true, // 显示导入按钮
		export: true, // 显示导出按钮
		print: true, // 显示打印按钮
		zoom: true, // 显示全屏按钮
		custom: true, // 显示自定义列按钮
	},
	proxyConfig: {
		seq: true, // 启用动态序号代理，每一页的序号会根据当前页数变化
		sort: true, // 启用排序代理，当点击排序时会自动触发 query 行为
		filter: true, // 启用筛选代理，当点击筛选时会自动触发 query 行为
		form: true, // 启用表单代理，当点击表单提交按钮时会自动触发 reload 行为
		props: {
			// 对应响应结果 Promise<{ result: [], page: { total: 100 } }>
			result: 'result', // 配置响应结果列表字段
			total: 'page.total', // 配置响应结果总页数字段
		},
		// 只接收Promise，具体实现自由发挥
		ajax: {
			// 当点击工具栏查询按钮或者手动提交指令 query或reload 时会被触发
			query: ({ page, sorts, filters, form }) => {
				const queryParams: any = { ...form };
				// 处理排序条件
				const firstSort = sorts[0];
				if (firstSort) {
					queryParams.sort = firstSort.field;
					queryParams.order = firstSort.order;
				}
				// 处理筛选条件
				filters.forEach(({ field, values }) => {
					queryParams[field] = values.join(',');
				});
				return fetch(
					`${serveApiUrl}/api/pub/page/list/${page.pageSize}/${
						page.currentPage
					}?${XEUtils.serialize(queryParams)}`
				).then((response) => response.json());
			},
			// 当点击工具栏删除按钮或者手动提交指令 delete 时会被触发
			delete: ({ body }) =>
				fetch(`${serveApiUrl}/api/pub/save`, {
					method: 'POST',
					headers: { 'Content-Type': 'application/json' },
					body: JSON.stringify(body),
				}).then((response) => response.json()),
			// 当点击工具栏保存按钮或者手动提交指令 save 时会被触发
			save: ({ body }) =>
				fetch(`${serveApiUrl}/api/pub/save`, {
					method: 'POST',
					headers: { 'Content-Type': 'application/json' },
					body: JSON.stringify(body),
				}).then((response) => response.json()),
		},
	},
	columns: [
		{ type: 'checkbox', title: 'ID', width: 120 },
		{
			field: 'name',
			title: 'Name',
			sortable: true,
			titlePrefix: { message: '名称必须填写！' },
			editRender: { name: 'input', attrs: { placeholder: '请输入名称' } },
		},
		{
			field: 'role',
			title: 'Role',
			sortable: true,
			titlePrefix: {
				useHTML: true,
				content:
					'点击链接：<a class="link" href="https://vxetable.cn" target="_blank">vxe-table官网</a>',
			},
			filters: [
				{ label: '前端开发', value: '前端' },
				{ label: '后端开发', value: '后端' },
				{ label: '测试', value: '测试' },
				{ label: '程序员鼓励师', value: '程序员鼓励师' },
			],
			filterMultiple: false,
			editRender: { name: 'input', attrs: { placeholder: '请输入角色' } },
		},
		{
			field: 'email',
			title: 'Email',
			width: 160,
			editRender: { name: '$input', props: { placeholder: '请输入邮件' } },
		},
		{
			field: 'nickname',
			title: 'Nickname',
			editRender: { name: 'input', attrs: { placeholder: '请输入昵称' } },
		},
		{
			field: 'sex',
			title: 'Sex',
			filters: [
				{ label: '男', value: '1' },
				{ label: '女', value: '0' },
			],
			editRender: {
				name: '$select',
				options: [],
				props: { placeholder: '请选择性别' },
			},
		},
		{
			field: 'age',
			title: 'Age',
			visible: false,
			sortable: true,
			editRender: {
				name: '$input',
				props: { type: 'number', min: 1, max: 120 },
			},
		},
		{
			field: 'amount',
			title: 'Amount',
			formatter({ cellValue }) {
				return cellValue
					? `￥${XEUtils.commafy(XEUtils.toNumber(cellValue), { digits: 2 })}`
					: '';
			},
			editRender: {
				name: '$input',
				props: { type: 'float', digits: 2, placeholder: '请输入数值' },
			},
		},
		{
			field: 'updateDate',
			title: 'Update Date',
			width: 160,
			visible: false,
			sortable: true,
			formatter({ cellValue }) {
				return XEUtils.toDateString(cellValue, 'yyyy-MM-dd HH:ss:mm');
			},
		},
		{
			field: 'createDate',
			title: 'Create Date',
			width: 160,
			visible: false,
			sortable: true,
			formatter({ cellValue }) {
				return XEUtils.toDateString(cellValue, 'yyyy-MM-dd');
			},
		},
	],
	importConfig: {
		remote: true,
		types: ['xlsx'],
		modes: ['insert'],
		// 自定义服务端导入
		importMethod({ file }) {
			const $grid = xGrid.value;
			const formBody = new FormData();
			formBody.append('file', file);
			return fetch(`${serveApiUrl}/api/pub/import`, {
				method: 'POST',
				body: formBody,
			})
				.then((response) => response.json())
				.then((data) => {
					VXETable.modal.message({
						content: `成功导入 ${data.result.insertRows} 条记录！`,
						status: 'success',
					});
					// 导入完成，刷新表格
					if ($grid) {
						$grid.commitProxy('query');
					}
				})
				.catch(() => {
					VXETable.modal.message({
						content: '导入失败，请检查数据是否正确！',
						status: 'error',
					});
				});
		},
	},
	exportConfig: {
		remote: true,
		types: ['xlsx'],
		modes: ['current', 'selected', 'all'],
		// 自定义服务端导出
		exportMethod({ options }) {
			const $grid = xGrid.value;
			if ($grid) {
				const proxyInfo = $grid.getProxyInfo();
				// 传给服务端的参数
				const body = {
					filename: options.filename,
					sheetName: options.sheetName,
					isHeader: options.isHeader,
					original: options.original,
					mode: options.mode,
					pager: proxyInfo ? proxyInfo.pager : null,
					ids:
						options.mode === 'selected'
							? options.data.map((item) => item.id)
							: [],
					fields: options.columns.map((column) => ({
						field: column.field,
						title: column.title,
					})),
				};
				// 开始服务端导出
				return fetch(`${serveApiUrl}/api/pub/export`, {
					method: 'POST',
					headers: { 'Content-Type': 'application/json' },
					body: JSON.stringify(body),
				})
					.then((response) => response.json())
					.then((data) => {
						if (data.id) {
							VXETable.modal.message({
								content: '导出成功，开始下载',
								status: 'success',
							});
							// 读取路径，请求文件
							fetch(`${serveApiUrl}/api/pub/export/download/${data.id}`).then(
								(response) => {
									response.blob().then((blob) => {
										// 开始下载
										VXETable.saveFile({
											filename: '导出数据',
											type: 'xlsx',
											content: blob,
										});
									});
								}
							);
						}
					})
					.catch(() => {
						VXETable.modal.message({ content: '导出失败！', status: 'error' });
					});
			}
			return Promise.resolve();
		},
	},
	checkboxConfig: {
		labelField: 'id',
		reserve: true,
		highlight: true,
		range: true,
	},
	editRules: {
		name: [
			{ required: true, message: 'app.body.valid.rName' },
			{ min: 3, max: 50, message: '名称长度在 3 到 50 个字符' },
		],
		email: [{ required: true, message: '邮件必须填写' }],
		role: [{ required: true, message: '角色必须填写' }],
	},
	editConfig: {
		trigger: 'click',
		mode: 'row',
		showStatus: true,
	},
});

const gridEvent = {
	proxyQuery() {
		console.log('数据代理查询事件');
	},
	proxyDelete() {
		console.log('数据代理删除事件');
	},
	proxySave() {
		console.log('数据代理保存事件');
	},
};

onMounted(() => {
	const sexList = [
		{ label: '女', value: '0' },
		{ label: '男', value: '1' },
	];
	const { formConfig, columns } = gridOptions;
	if (columns) {
		const sexColumn = columns[5];
		if (sexColumn && sexColumn.editRender) {
			sexColumn.editRender.options = sexList;
		}
	}
	if (formConfig && formConfig.items) {
		const sexItem = formConfig.items[4];
		if (sexItem && sexItem.itemRender) {
			sexItem.itemRender.options = sexList;
		}
	}
});
</script>
